package com.qf.zxq.code.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import io.swagger.annotations.ApiModel;
import io.swagger.annotations.ApiModelProperty;
import lombok.Data;

/**
 * 商品表
 */
@ApiModel(description = "商品表")
@Data
@TableName(value = "commodity")
public class Commodity {
    /**
     * 商品id
     */
    @TableId(value = "commodity_id", type = IdType.INPUT)
    @ApiModelProperty(value = "商品id")
    private Integer commodityId;

    /**
     * 商品分类ID
     */
    @TableField(value = "categories_id")
    @ApiModelProperty(value = "商品分类ID")
    private Integer categoriesId;

    /**
     * 商品名称
     */
    @TableField(value = "commodity_name")
    @ApiModelProperty(value = "商品名称")
    private String commodityName;

    /**
     * 副标题
     */
    @TableField(value = "subtitle")
    @ApiModelProperty(value = "副标题")
    private String subtitle;

    /**
     * 商品品牌
     */
    @TableField(value = "product_brand")
    @ApiModelProperty(value = "商品品牌")
    private Integer productBrand;

    /**
     * 备注
     */
    @TableField(value = "remark")
    @ApiModelProperty(value = "备注")
    private String remark;

    /**
     * 商品货号-商品编号
     */
    @TableField(value = "product_code")
    @ApiModelProperty(value = "商品货号-商品编号")
    private String productCode;

    /**
     * 商品售价
     */
    @TableField(value = "product_selling_price")
    @ApiModelProperty(value = "商品售价")
    private Double productSellingPrice;

    /**
     * 市场价
     */
    @TableField(value = "market_price")
    @ApiModelProperty(value = "市场价")
    private Double marketPrice;

    /**
     * 商品库存
     */
    @TableField(value = "commodity_stocks")
    @ApiModelProperty(value = "商品库存")
    private Integer commodityStocks;

    /**
     * 计量单位
     */
    @TableField(value = "unit_of_measurement")
    @ApiModelProperty(value = "计量单位")
    private Integer unitOfMeasurement;

    /**
     * 商品重量
     */
    @TableField(value = "commodity_weight")
    @ApiModelProperty(value = "商品重量")
    private Double commodityWeight;

    /**
     * 上架状态 1为上架 0为下架
     */
    @TableField(value = "shelf_status")
    @ApiModelProperty(value = "上架状态 1为上架 0为下架")
    private Integer shelfStatus;

    /**
     * 审核状况 1为审核通过 0为审核不通过
     */
    @TableField(value = "review_status")
    @ApiModelProperty(value = "审核状况 1为审核通过 0为审核不通过")
    private Integer reviewStatus;

    public static final String COL_COMMODITY_ID = "commodity_id";

    public static final String COL_CATEGORIES_ID = "categories_id";

    public static final String COL_COMMODITY_NAME = "commodity_name";

    public static final String COL_SUBTITLE = "subtitle";

    public static final String COL_PRODUCT_BRAND = "product_brand";

    public static final String COL_REMARK = "remark";

    public static final String COL_PRODUCT_CODE = "product_code";

    public static final String COL_PRODUCT_SELLING_PRICE = "product_selling_price";

    public static final String COL_MARKET_PRICE = "market_price";

    public static final String COL_COMMODITY_STOCKS = "commodity_stocks";

    public static final String COL_UNIT_OF_MEASUREMENT = "unit_of_measurement";

    public static final String COL_COMMODITY_WEIGHT = "commodity_weight";

    public static final String COL_SHELF_STATUS = "shelf_status";

    public static final String COL_REVIEW_STATUS = "review_status";
}